æ¡è¿Žæ‚¨ä¾†åˆ°æœ¬åº—ï¼æ‚¨å¯ä»¥
登入
或
æˆç‚ºæœƒå“¡
使用完整功能
首é
商å“備忘簿 (0)
會員ä¸å¿ƒ
購物車
çµå¸³
購物車
0 ä»¶å•†å“ NT0
æ‚¨çš„è³¼ç‰©è»Šæ²’æœ‰åŠ å…¥ä»»ä½•å•†å“
Home
å¸ç¿’
動手åš
Nulla a odio
Amet luctus libero
Aenean placerat
Hendrerit libero
Luctus et eu
Cliquet lectus rutrum
Sed quam lore
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Siam eget arcu
Ante erat sagittis rhoncus diam eget arcu
Ante erat sagittis rhoncus diam eget arcu tempor faucibus fringilla quam vulputate
éŠæˆ²å’Œæ‹¼åœ–
Nullam aliquet ant
Test2
Pellentesque mauris
Quisque eu augue
Item page
動作類玩具
最新消æ¯
推薦賺çŽé‡‘
商å“類別
Aenean placerat (7)
Amet luctus libero (18)
Mice and Trackballs (6)
Praesent orci dui (2)
Quis euismod neque (1)
Cliquet lectus rutrum (3)
test 3 (0)
test4 (0)
test 5 (0)
Hendrerit libero (0)
暢銷商å“
Fermentum quis tinci
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT1,000
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Fringilla eleifend
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
特價
Risus viverra ullam
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
NT95
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Donec lacinia volu
下載PDF &nb...
NT120
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
首é
»
æœå°‹å•†å“
æœå°‹å•†å“
æœå°‹æ¢ä»¶
æœå°‹å—串
所有類別
Aenean placerat
Amet luctus libero
Mice and Trackballs
test1
test2
Praesent orci dui
Quis euismod neque
Cliquet lectus rutrum
test 3
test4
test 5
Hendrerit libero
包å«å目錄
包å«å•†å“說明
符åˆæœå°‹æ¢ä»¶çš„商å“
排列方å¼
圖文
圖片
排åºæ–¹å¼
é è¨
å稱 A - Z
å稱 Z - A
åƒ¹æ ¼ä½Ž > 高
åƒ¹æ ¼é«˜ > 低
評價高 > 低
評價低 > 高
型號 A - Z
型號 Z - A
顯示數é‡
6
25
50
75
100
商å“比較清單 (0)
1
2
>
>|
第1 ~ 6ç† (å…±11ç†)
Donec lacinia volu
下載PDF &nb...
NT120
å«ç¨…價 NT120
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Fermentum quis tinci
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT1,000
å«ç¨…價 NT1,000
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Fringilla eleifend
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
å«ç¨…價 NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
特價
Lacinia sapien
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT120
NT98
å«ç¨…價 NT98
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Metus placerat
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
å«ç¨…價 NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
特價
Posuere non euis
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT120
NT98
å«ç¨…價 NT98
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
排列方å¼
圖文
/
圖片
商å“比較清單 (0)
1
2
>
>|
第1 ~ 6ç† (å…±11ç†)
Design By
Kinew Co.,
Queries: 123, Total time: 51.105 ms [
By time
] [
By id
] [
By file
]
1
(0.403)
SELECT
*
FROM
oc_store
WHERE
REPLACE(`ssl`, 'www.', '') = 'https://cart.kinew.com/jouet/'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:49
2
(2.176)
SELECT
*
FROM
oc_setting
WHERE
store_id = '0'
OR
store_id = '0'
ORDER BY
store_id
ASC
/opt/lampp/htdocs_vsite/cart/jouet/index.php:61
3
(0.585)
SELECT
*
FROM
`oc_language`
WHERE
status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:140
4
(0.499)
SELECT
*
FROM
oc_currency
/opt/lampp/htdocs_vsite/cart/jouet/system/library/currency.php:13
5
(0.519)
SELECT
*
FROM
oc_weight_class wc
LEFT JOIN
oc_weight_class_description wcd
ON
(wc.weight_class_id = wcd.weight_class_id)
WHERE
wcd.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/weight.php:9
6
(0.535)
SELECT
*
FROM
oc_length_class mc
LEFT JOIN
oc_length_class_description mcd
ON
(mc.length_class_id = mcd.length_class_id)
WHERE
mcd.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/length.php:9
7
(1.631)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
8
(0.599)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
9
(0.664)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
10
(0.660)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '62'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
11
(0.568)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '63'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
12
(0.563)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '64'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
13
(0.648)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
14
(0.563)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '40'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
15
(0.562)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '41'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
16
(0.561)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '42'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
17
(0.607)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
18
(1.273)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
(pd.tag LIKE '%aliquam libero%')
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
19
(1.515)
SELECT
p.product_id, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
(pd.tag LIKE '%aliquam libero%')
GROUP BY
p.product_id
ORDER BY
p.sort_order
ASC
, LCASE(pd.name)
ASC
LIMIT
0,6
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:222
20
(1.308)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '53'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
21
(0.493)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '46'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
22
(0.481)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '52'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
23
(0.496)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '57'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
24
(0.481)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '56'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
25
(0.495)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '58'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
26
(1.293)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
27
(0.215)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
28
(0.212)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
29
(0.203)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
30
(0.207)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
31
(0.204)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
32
(0.233)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
33
(0.223)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
34
(0.217)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
35
(0.219)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
36
(0.209)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
37
(0.204)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
38
(0.206)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
39
(0.203)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
40
(0.200)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
41
(0.201)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
42
(0.416)
SELECT
*
FROM
oc_layout_route
WHERE
'product/search' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
43
(0.262)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
44
(0.725)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
45
(0.505)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '17'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
46
(0.566)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
47
(0.255)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '61'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
48
(0.652)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
49
(0.425)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
50
(0.266)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
51
(0.261)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
52
(0.270)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '34'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
53
(0.647)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
54
(0.265)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
55
(0.255)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '41'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
56
(0.257)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
57
(0.228)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '33'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
58
(0.559)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
59
(0.303)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
60
(0.238)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
61
(0.573)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
62
(0.208)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
63
(0.211)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
64
(0.205)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
65
(0.203)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
66
(0.201)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
67
(0.206)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
68
(0.203)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
69
(0.750)
SELECT
*
FROM
oc_banner_image bi
LEFT JOIN
oc_banner_image_description bid
ON
(bi.banner_image_id = bid.banner_image_id)
WHERE
bi.banner_id = '9'
AND
bid.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/banner.php:4
70
(0.140)
SELECT
*
FROM
oc_layout_route
WHERE
'product/search' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
71
(0.110)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
72
(0.127)
SELECT
*
FROM
oc_layout_route
WHERE
'product/search' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
73
(0.118)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
74
(0.120)
SELECT
*
FROM
oc_layout_route
WHERE
'product/search' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
75
(0.113)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
76
(1.782)
SELECT
*
FROM
oc_information i
LEFT JOIN
oc_information_description id
ON
(i.information_id = id.information_id)
LEFT JOIN
oc_information_to_store i2s
ON
(i.information_id = i2s.information_id)
WHERE
id.language_id = '4'
AND
i2s.store_id = '0'
AND
i.status = '1'
ORDER BY
i.sort_order, LCASE(id.title)
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/information.php:10
77
(0.122)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
78
(0.122)
SELECT
*
FROM
oc_layout_route
WHERE
'product/search' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
79
(0.705)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
80
(0.276)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '17'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
81
(0.570)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
82
(0.255)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '61'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
83
(0.704)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
84
(0.280)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
85
(0.260)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
86
(0.257)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
87
(0.237)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '34'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
88
(0.648)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
89
(0.265)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
90
(0.259)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '41'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
91
(0.257)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
92
(0.228)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '33'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
93
(0.607)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
94
(0.230)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
95
(0.207)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
96
(0.212)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
97
(0.206)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
98
(0.211)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
99
(0.205)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
100
(0.205)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
101
(0.206)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
102
(0.209)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
103
(0.204)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
104
(0.132)
SELECT
*
FROM
oc_banner_image bi
LEFT JOIN
oc_banner_image_description bid
ON
(bi.banner_image_id = bid.banner_image_id)
WHERE
bi.banner_id = '9'
AND
bid.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/banner.php:4
105
(0.147)
SELECT
*
FROM
oc_setting
WHERE
store_id = '0'
AND
`group` = 'pavmegamenubase_params'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/setting.php:6
106
(0.891)
SELECT
m.*, md.title,md.description
FROM
oc_megamenu m
LEFT JOIN
oc_megamenu_description md
ON
m.megamenu_id=md.megamenu_id
AND
language_id=4
WHERE
m.`published`=1
AND
store_id=0
ORDER BY
`position`
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/menu/megamenu.php:47
107
(0.737)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
108
(0.570)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
109
(0.652)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
110
(0.292)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
111
(0.260)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
112
(0.255)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
113
(0.659)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
114
(0.266)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
115
(0.259)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '41'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
116
(0.254)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
117
(0.575)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
118
(0.122)
SELECT
*
FROM
oc_layout_route
WHERE
'product/search' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
119
(0.113)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
120
(0.117)
SELECT
*
FROM
oc_language
ORDER BY
sort_order, name
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/localisation/language.php:15
121
(0.106)
SELECT
*
FROM
oc_currency
ORDER BY
title
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/localisation/currency.php:15
122
(0.103)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'total'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
123
(0.489)
SELECT
SUM(amount)
AS
total
FROM
oc_customer_transaction
WHERE
customer_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/customer.php:157